package com.byxm.wlgw.service;

import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

import com.byxm.wlgw.bean.Splb_fBean;
import com.byxm.wlgw.common.DataBaseAccess;
import com.byxm.wlgw.query.Splb_fQuery;

public class Splb_fService {
	Splb_fQuery query=new Splb_fQuery();
	public List<Splb_fBean> findSplbf(){
		
		DataBaseAccess dba=null;
		List<Splb_fBean> list=new ArrayList<Splb_fBean>();
		try {
			dba = new DataBaseAccess();
			ResultSet rs = dba.executeQuery(query.findAll());
			while(rs.next()){
				Splb_fBean bean=new Splb_fBean();
				bean.setSplbfid(rs.getInt("splbfid"));
				bean.setSplbm(rs.getString("splbm"));
				list.add(bean);
			}
			rs.close();
		} catch (Exception e) {
			e.printStackTrace();
		}finally{
			try {
				dba.releaseConnect();
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
		return list;
	}
}
